/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package queenb.net.entitybean;

import com.lowagie.text.html.simpleparser.Img;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.Serializable;
import java.sql.Blob;
import java.sql.Date;
import java.sql.SQLException;
import java.sql.Types;

import java.util.List;
import oracle.jdbc.OracleTypes;
import oracle.sql.BLOB;
import org.hibernate.annotations.Entity;
import queenb.net.annotation.Mapping;
import queenb.net.datacontrol.DataControl;

/**
 *
 * @author thanhct
 */
@Entity
public class K100 extends DataControl<K100> implements Serializable {

    @Mapping(name = "pk100", typeMapping = OracleTypes.INTEGER)
    public int pk100;
    @Mapping(name = "fn100n", typeMapping = OracleTypes.INTEGER)
    private int fn100n;
    @Mapping(name = "fn100g", typeMapping = OracleTypes.INTEGER)
    private int fn100g;
    @Mapping(name = "fh200", typeMapping = OracleTypes.INTEGER)
    public int fh200;
    @Mapping(name = "KD115", typeMapping = OracleTypes.DATE)
    private Date KD115;
    @Mapping(name = "fh075", typeMapping = OracleTypes.INTEGER)
    private int fh075;
    @Mapping(name = "ph200", typeMapping = OracleTypes.INTEGER)
    public int ph200;
    @Mapping(name = "fk200", typeMapping = OracleTypes.INTEGER)
    public int fk200;
    @Mapping(name = "fk250", typeMapping = OracleTypes.CHAR)
    public String fk250;
    @Mapping(name = "fk300", typeMapping = OracleTypes.INTEGER)
    public int fk300;
    @Mapping(name = "fh300", typeMapping = OracleTypes.INTEGER)
    public int fh300;
    @Mapping(name = "fk400", typeMapping = OracleTypes.INTEGER)
    public int fk400;
    @Mapping(name = "fk350", typeMapping = OracleTypes.INTEGER)
    public int fk350;
    @Mapping(name = "fh200q", typeMapping = OracleTypes.INTEGER)
    public int fh200q;
    @Mapping(name = "kv101", typeMapping = OracleTypes.CHAR)
    public String kv101;
    @Mapping(name = "kv102", typeMapping = OracleTypes.CHAR)
    public String kv102;
    @Mapping(name = "kv103", typeMapping = OracleTypes.CHAR)
    public String kv103;
    @Mapping(name = "kv104", typeMapping = OracleTypes.CHAR)
    public String kv104;
    @Mapping(name = "kv105", typeMapping = OracleTypes.CHAR)
    public String kv105;
    @Mapping(name = "kv106", typeMapping = OracleTypes.CHAR)
    public String kv106;
    @Mapping(name = "kv110", typeMapping = OracleTypes.CHAR)
    private String kv110;
    @Mapping(name = "hv201", typeMapping = OracleTypes.CHAR)
    public String hv201;
    @Mapping(name = "hv202", typeMapping = OracleTypes.CHAR)
    private String hv202;
    @Mapping(name = "hv203", typeMapping = OracleTypes.CHAR)
    private String hv203;
    @Mapping(name = "kv201", typeMapping = OracleTypes.CHAR)
    public String kv201;
    @Mapping(name = "kv112", typeMapping = OracleTypes.CHAR)
    private String kv112;
    @Mapping(name = "kv251", typeMapping = OracleTypes.CHAR)
    public String kv251;
    @Mapping(name = "kv302", typeMapping = OracleTypes.CHAR)
    public String kv302;
    @Mapping(name = "kv351", typeMapping = OracleTypes.CHAR)
    public String kv351;
    @Mapping(name = "vv031", typeMapping = OracleTypes.CHAR)
    private String vv031;
    @Mapping(name = "kv401", typeMapping = OracleTypes.CHAR)
    public String kv401;
    @Mapping(name = "hv211", typeMapping = OracleTypes.CHAR)
    public String hv211;
    @Mapping(name = "ph250", typeMapping = OracleTypes.INTEGER)
    public int ph250;
    @Mapping(name = "fh250", typeMapping = OracleTypes.INTEGER)
    public int fh250;
    @Mapping(name = "fh200p", typeMapping = OracleTypes.INTEGER)
    public int fh200p;
    @Mapping(name = "childexist", typeMapping = OracleTypes.INTEGER)
    private int childexist;
    @Mapping(name = "hn456", typeMapping = OracleTypes.INTEGER)
    private int hn456;
    private String number;
    @Mapping(name = "kv954", typeMapping = OracleTypes.CHAR)
    private String kv954;
    @Mapping(name = "kv952", typeMapping = OracleTypes.CHAR)
    private String kv952;
    @Mapping(name = "kv108", typeMapping = OracleTypes.CHAR)
    private String kv108;
    @Mapping(name = "kv957", typeMapping = OracleTypes.CHAR)
    private String kv957;
    @Mapping(name = "kv958", typeMapping = OracleTypes.CHAR)
    private String kv958;
    @Mapping(name = "kv961", typeMapping = OracleTypes.CHAR)
    private String kv961;
    @Mapping(name = "kv967", typeMapping = OracleTypes.CHAR)
    private String kv967;
    @Mapping(name = "kv969", typeMapping = OracleTypes.CHAR)
    private String kv969;
    @Mapping(name = "kv962", typeMapping = OracleTypes.CHAR)
    private String kv962;
    @Mapping(name = "kn114", typeMapping = OracleTypes.INTEGER)
    private int kn114;
    @Mapping(name = "fn850", typeMapping = OracleTypes.INTEGER)
    private int fn850;
    @Mapping(name = "FV350", typeMapping = OracleTypes.INTEGER)
    private int fv350;
    @Mapping(name = "tnhiem", typeMapping = OracleTypes.CHAR)
    private String tnhiem;
    @Mapping(name = "gthieu", typeMapping = OracleTypes.CHAR)
    private String gthieu;
    @Mapping(name = "nv552", typeMapping = OracleTypes.CHAR)
    private String nv552;
    @Mapping(name = "fn550", typeMapping = OracleTypes.INTEGER)
    private int fn550;
    @Mapping(name = "val", typeMapping = OracleTypes.INTEGER)
    private int val;
    @Mapping(name = "label", typeMapping = OracleTypes.CHAR)
    private String label;
    @Mapping(name = "kb113", typeMapping = OracleTypes.BLOB)
    public byte[] kb113;
    @Mapping(name = "kl198", typeMapping = Types.CHAR)
    private String kl198;
    @Mapping(name = "kl199", typeMapping = Types.CHAR)
    private String kl199;
//    @Mapping(name = "kb113", typeMapping = Types.BLOB)
//    public byte[] logo;
    @Mapping(name = "kv301", typeMapping = OracleTypes.CHAR)
    private String kv301;
    @Mapping(name = "kv331", typeMapping = OracleTypes.CHAR)
    private String kv331;
    @Mapping(name = "fk330", typeMapping = OracleTypes.INTEGER)
    private int fk330;
    @Mapping(name = "ROWSS", typeMapping = OracleTypes.INTEGER)
    private int rowss;
    private String gthieust;
    private String tnhiemst;
    private boolean selected;
    private String subKv103;
    private String subKv105;// cat chuoi cho ten giao dich của cong ty
    private String subAddress;
    @Mapping(name = "TEL", typeMapping = OracleTypes.CHAR)
    private String tel;
    @Mapping(name = "EMAIL", typeMapping = OracleTypes.CHAR)
    private String email1;
    @Mapping(name = "DC", typeMapping = OracleTypes.CHAR)
    private String dc;
    @Mapping(name = "MST", typeMapping = OracleTypes.CHAR)
    private String mst;
    @Mapping(name = "NV754", typeMapping = OracleTypes.CHAR)
    private String nv754;
    private String kv101st;

    public String getKv103() {
        return kv103;
    }

    public void setKv103(String kv103) {
        this.kv103 = kv103;
    }

    public String getKv104() {
        return kv104;
    }

    public void setKv104(String kv104) {
        this.kv104 = kv104;
    }

    public String getKv105() {
        return kv105;
    }

    public void setKv105(String kv105) {
        this.kv105 = kv105;
    }

    public String getKv106() {
        return kv106;
    }

    public void setKv106(String kv106) {
        this.kv106 = kv106;
    }

    public int getFh200() {
        return fh200;
    }

    public void setFh200(int fh200) {
        this.fh200 = fh200;
    }

    public int getFh300() {
        return fh300;
    }

    public void setFh300(int fh300) {
        this.fh300 = fh300;
    }

    public int getFk200() {
        return fk200;
    }

    public void setFk200(int fk200) {
        this.fk200 = fk200;
    }

    public String getFk250() {
        return fk250;
    }

    public void setFk250(String fk250) {
        this.fk250 = fk250;
    }

    public int getFk300() {
        return fk300;
    }

    public void setFk300(int fk300) {
        this.fk300 = fk300;
    }

    public String getFullName() {
        return kv103;
    }

    public String getEmail() {
        return kv105;
    }

    public String getPhone() {
        return kv106;
    }

    public int getFk350() {
        return fk350;
    }

    public void setFk350(int fk350) {
        this.fk350 = fk350;
    }

    public int getFk400() {
        return fk400;
    }

    public void setFk400(int fk400) {
        this.fk400 = fk400;
    }

    public String getKv101() {
        return kv101;
    }

    public void setKv101(String kv101) {
        this.kv101 = kv101;
    }

    public String getKv102() {
        return kv102;
    }

    public void setKv102(String kv102) {
        this.kv102 = kv102;
    }

    public int getPk100() {
        return pk100;
    }

    public void setPk100(int pk100) {
        this.pk100 = pk100;
    }

    public String getHv201() {
        return hv201;
    }

    public void setHv201(String hv201) {
        this.hv201 = hv201;
    }

    public String getKv201() {
        return kv201;
    }

    public void setKv201(String kv201) {
        this.kv201 = kv201;
    }

    public String getKv251() {
        return kv251;
    }

    public void setKv251(String kv251) {
        this.kv251 = kv251;
    }

    public String getKv302() {
        return kv302;
    }

    public void setKv302(String kv302) {
        this.kv302 = kv302;
    }

    public String getKv351() {
        return kv351;
    }

    public void setKv351(String kv351) {
        this.kv351 = kv351;
    }

    public String getKv401() {
        return kv401;
    }

    public void setKv401(String kv401) {
        this.kv401 = kv401;
    }

    public int getFh200q() {
        return fh200q;
    }

    public void setFh200q(int fh200q) {
        this.fh200q = fh200q;
    }

    /**
     * @return the hv211
     */
    public String getHv211() {
        return hv211;
    }

    /**
     * @param hv211 the hv211 to set
     */
    public void setHv211(String hv211) {
        this.hv211 = hv211;
    }

    /**
     * @return the ph200
     */
    public int getPh200() {
        return ph200;
    }

    /**
     * @param ph200 the ph200 to set
     */
    public void setPh200(int ph200) {
        this.ph200 = ph200;
    }

    /**
     * @return the ph250
     */
    public int getPh250() {
        return ph250;
    }

    /**
     * @param ph250 the ph250 to set
     */
    public void setPh250(int ph250) {
        this.ph250 = ph250;
    }

    /**
     * @return the fh250
     */
    public int getFh250() {
        return fh250;
    }

    /**
     * @param fh250 the fh250 to set
     */
    public void setFh250(int fh250) {
        this.fh250 = fh250;
    }

    /**
     * @return the fh200p
     */
    public int getFh200p() {
        return fh200p;
    }

    /**
     * @param fh200p the fh200p to set
     */
    public void setFh200p(int fh200p) {
        this.fh200p = fh200p;
    }

    /**
     * @return the childexist
     */
    public int getChildexist() {
        return childexist;
    }

    /**
     * @param childexist the childexist to set
     */
    public void setChildexist(int childexist) {
        this.childexist = childexist;
    }

    /**
     * @return the hn456
     */
    public int getHn456() {
        return hn456;
    }

    /**
     * @param hn456 the hn456 to set
     */
    public void setHn456(int hn456) {
        this.hn456 = hn456;
    }

    /**
     * @return the hv202
     */
    public String getHv202() {
        return hv202;
    }

    /**
     * @param hv202 the hv202 to set
     */
    public void setHv202(String hv202) {
        this.hv202 = hv202;
    }

    /**
     * @return the hv203
     */
    public String getHv203() {
        return hv203;
    }

    /**
     * @param hv203 the hv203 to set
     */
    public void setHv203(String hv203) {
        this.hv203 = hv203;
    }

    /**
     * @return the fh075
     */
    public int getFh075() {
        return fh075;
    }

    /**
     * @param fh075 the fh075 to set
     */
    public void setFh075(int fh075) {
        this.fh075 = fh075;
    }

    /**
     * @return the number
     */
    public String getNumber() {
        return number;
    }

    /**
     * @param number the number to set
     */
    public void setNumber(String number) {
        this.number = number;
    }

    /**
     * @return the kv954
     */
    public String getKv954() {
        return kv954;
    }

    /**
     * @param kv954 the kv954 to set
     */
    public void setKv954(String kv954) {
        this.kv954 = kv954;
    }

    /**
     * @return the kv952
     */
    public String getKv952() {
        return kv952;
    }

    /**
     * @param kv952 the kv952 to set
     */
    public void setKv952(String kv952) {
        this.kv952 = kv952;
    }

    /**
     * @return the kv957
     */
    public String getKv957() {
        return kv957;
    }

    /**
     * @param kv957 the kv957 to set
     */
    public void setKv957(String kv957) {
        this.kv957 = kv957;
    }

    /**
     * @return the kv961
     */
    public String getKv961() {
        return kv961;
    }

    /**
     * @param kv961 the kv961 to set
     */
    public void setKv961(String kv961) {
        this.kv961 = kv961;
    }

    /**
     * @return the kv969
     */
    public String getKv969() {
        return kv969;
    }

    /**
     * @param kv969 the kv969 to set
     */
    public void setKv969(String kv969) {
        this.kv969 = kv969;
    }

    /**
     * @return the kv958
     */
    public String getKv958() {
        return kv958;
    }

    /**
     * @param kv958 the kv958 to set
     */
    public void setKv958(String kv958) {
        this.kv958 = kv958;
    }

    /**
     * @return the kn114
     */
    public int getKn114() {
        return kn114;
    }

    /**
     * @param kn114 the kn114 to set
     */
    public void setKn114(int kn114) {
        this.kn114 = kn114;
    }

    /**
     * @return the fn850
     */
    public int getFn850() {
        return fn850;
    }

    /**
     * @param fn850 the fn850 to set
     */
    public void setFn850(int fn850) {
        this.fn850 = fn850;
    }

    /**
     * @return the tnhiem
     */
    public String getTnhiem() {
        return tnhiem;
    }

    /**
     * @param tnhiem the tnhiem to set
     */
    public void setTnhiem(String tnhiem) {
        this.tnhiem = tnhiem;
    }

    /**
     * @return the gthieu
     */
    public String getGthieu() {
        return gthieu;
    }

    /**
     * @param gthieu the gthieu to set
     */
    public void setGthieu(String gthieu) {
        this.gthieu = gthieu;
    }

    /**
     * @return the nv552
     */
    public String getNv552() {
        return nv552;
    }

    /**
     * @param nv552 the nv552 to set
     */
    public void setNv552(String nv552) {
        this.nv552 = nv552;
    }

    /**
     * @return the fn550
     */
    public int getFn550() {
        return fn550;
    }

    /**
     * @param fn550 the fn550 to set
     */
    public void setFn550(int fn550) {
        this.fn550 = fn550;
    }

    /**
     * @return the kv110
     */
    public String getKv110() {
        return kv110;
    }

    /**
     * @param kv110 the kv110 to set
     */
    public void setKv110(String kv110) {
        this.kv110 = kv110;
    }

    /**
     * @return the val
     */
    public int getVal() {
        return val;
    }

    /**
     * @param val the val to set
     */
    public void setVal(int val) {
        this.val = val;
    }

    /**
     * @return the label
     */
    public String getLabel() {
        return label;
    }

    /**
     * @param label the label to set
     */
    public void setLabel(String label) {
        this.label = label;
    }

    /**
     * @return the kv962
     */
    public String getKv962() {
        return kv962;
    }

    /**
     * @param kv962 the kv962 to set
     */
    public void setKv962(String kv962) {
        this.kv962 = kv962;
    }

    /**
     * @return the kv967
     */
    public String getKv967() {
        return kv967;
    }

    /**
     * @param kv967 the kv967 to set
     */
    public void setKv967(String kv967) {
        this.kv967 = kv967;
    }

    /**
     * @return the rowss
     */
    public int getRowss() {
        return rowss;
    }

    /**
     * @param rowss the rowss to set
     */
    public void setRowss(int rowss) {
        this.rowss = rowss;
    }

    /**
     * @return the fn100n
     */
    public int getFn100n() {
        return fn100n;
    }

    /**
     * @param fn100n the fn100n to set
     */
    public void setFn100n(int fn100n) {
        this.fn100n = fn100n;
    }

    /**
     * @return the fn100g
     */
    public int getFn100g() {
        return fn100g;
    }

    /**
     * @param fn100g the fn100g to set
     */
    public void setFn100g(int fn100g) {
        this.fn100g = fn100g;
    }

    /**
     * @return the selected
     */
    public boolean isSelected() {
        return selected;
    }

    /**
     * @param selected the selected to set
     */
    public void setSelected(boolean selected) {
        this.selected = selected;
    }

    /**
     * @return the kv301
     */
    public String getKv301() {
        return kv301;
    }

    /**
     * @param kv301 the kv301 to set
     */
    public void setKv301(String kv301) {
        this.kv301 = kv301;
    }

    /**
     * @return the kv331
     */
    public String getKv331() {
        return kv331;
    }

    /**
     * @param kv331 the kv331 to set
     */
    public void setKv331(String kv331) {
        this.kv331 = kv331;
    }

    /**
     * @return the fk330
     */
    public int getFk330() {
        return fk330;
    }

    /**
     * @param fk330 the fk330 to set
     */
    public void setFk330(int fk330) {
        this.fk330 = fk330;
    }

    /**
     * @return the gthieust
     */
    public String getGthieust() {
        if (gthieu != null) {
            if (gthieu.indexOf("@") != -1) {
                gthieust = gthieu.substring(0, gthieu.indexOf("@"));
            } else {
                gthieust = gthieu;
            }

        }
        return gthieust;
    }

    /**
     * @param gthieust the gthieust to set
     */
    public void setGthieust(String gthieust) {
        this.gthieust = gthieust;
    }

    /**
     * @return the tnhiemst
     */
    public String getTnhiemst() {
        if (tnhiem != null) {
            if (tnhiem.indexOf("@") != -1) {
                tnhiemst = tnhiem.substring(0, tnhiem.indexOf("@"));
            } else {
                tnhiemst = tnhiem;
            }

        }
        return tnhiemst;
    }

    /**
     * @param tnhiemst the tnhiemst to set
     */
    public void setTnhiemst(String tnhiemst) {
        this.tnhiemst = tnhiemst;
    }

    /**
     * @return the kv108
     */
    public String getKv108() {
        return kv108;
    }

    /**
     * @param kv108 the kv108 to set
     */
    public void setKv108(String kv108) {
        this.kv108 = kv108;
    }

    /**
     * @return the tel
     */
    public String getTel() {
        return tel;
    }

    /**
     * @param tel the tel to set
     */
    public void setTel(String tel) {
        this.tel = tel;
    }

    /**
     * @return the dc
     */
    public String getDc() {
        return dc;
    }

    /**
     * @param dc the dc to set
     */
    public void setDc(String dc) {
        this.dc = dc;
    }

    /**
     * @return the mst
     */
    public String getMst() {
        return mst;
    }

    /**
     * @param mst the mst to set
     */
    public void setMst(String mst) {
        this.mst = mst;
    }

    /**
     * @return the email1
     */
    public String getEmail1() {
        return email1;
    }

    /**
     * @param email1 the email1 to set
     */
    public void setEmail1(String email1) {
        this.email1 = email1;
    }

    /**
     * @return the kb113
     */
    public byte[] getKb113() {
        return kb113;
    }

    /**
     * @param kb113 the kb113 to set
     */
    public void setKb113(byte[] kb113) {
        this.kb113 = kb113;
    }

    /**
     * @return the kl198
     */
    public String getKl198() {
        return kl198;
    }

    /**
     * @param kl198 the kl198 to set
     */
    public void setKl198(String kl198) {
        this.kl198 = kl198;
    }

    /**
     * @return the kl199
     */
    public String getKl199() {
        return kl199;
    }

    /**
     * @param kl199 the kl199 to set
     */
    public void setKl199(String kl199) {
        this.kl199 = kl199;
    }

    /**
     * @return the kv101st
     */
    public String getKv101st() {
        if (kv101 != null) {

            if (kv101.length() > 23) {
                kv101st = kv101.substring(0, 23) + "...";
            } else {
                kv101st = kv101;
            }
        }
        return kv101st;
    }

    /**
     * @param kv101st the kv101st to set
     */
    public void setKv101st(String kv101st) {
        this.kv101st = kv101st;
    }

    /**
     * @return the vv031
     */
    public String getVv031() {
        return vv031;
    }

    /**
     * @param vv031 the vv031 to set
     */
    public void setVv031(String vv031) {
        this.vv031 = vv031;
    }

    /**
     * @return the kv112
     */
    public String getKv112() {
        return kv112;
    }

    /**
     * @param kv112 the kv112 to set
     */
    public void setKv112(String kv112) {
        this.kv112 = kv112;
    }

    /**
     * @return the fv350
     */
    public int getFv350() {
        return fv350;
    }

    /**
     * @param fv350 the fv350 to set
     */
    public void setFv350(int fv350) {
        this.fv350 = fv350;
    }

    /**
     * @return the nv754
     */
    public String getNv754() {
        return nv754;
    }

    /**
     * @param nv754 the nv754 to set
     */
    public void setNv754(String nv754) {
        this.nv754 = nv754;
    }

    /**
     * @return the KD115
     */
    public Date getKD115() {
        return KD115;
    }

    /**
     * @param KD115 the KD115 to set
     */
    public void setKD115(Date KD115) {
        this.KD115 = KD115;
    }

    /**
     * @return the subKv103
     */
    public String getSubKv103() {
          if(kv103!=null){
            if(kv103.length()> 25){
            subKv103 = kv103.substring(0,25)+"...";
           
        }else{
            subKv103 = getKv103();
        }
        }
        return subKv103;
    }

    /**
     * @param subKv103 the subKv103 to set
     */
    public void setSubKv103(String subKv103) {
        this.subKv103 = subKv103;
    }

    /**
     * @return the subAddress
     */
    public String getSubAddress() {
         if(kv952!=null){
            if(kv952.length()> 50){
            subAddress = kv952.substring(0,50)+"...";
           
        }else{
            subAddress = getKv952();
        }
        }
        return subAddress;
    }

    /**
     * @param subAddress the subAddress to set
     */
    public void setSubAddress(String subAddress) {
        this.subAddress = subAddress;
    }

    /**
     * @return the subKv105
     */
    public String getSubKv105() {
         if (kv105 != null) {
            if (kv105.length() >15) {
                subKv105 = kv105.substring(0, 15) + "...";

            } else {
                subKv105 = getKv105();
            }
        }
        return subKv105;
    }

    /**
     * @param subKv105 the subKv105 to set
     */
    public void setSubKv105(String subKv105) {
        this.subKv105 = subKv105;
    }
}
